import openpyxl

workbook = openpyxl.load_workbook("英才学校小学部.xlsx")
workbook1 = openpyxl.Workbook()
Sheet1 = workbook1['Sheet']
sheetname = workbook.sheetnames
sheet = workbook['1.1班']
row = sheet[5]
print(row)
row1 = []
for y in row:
    row1.append(y.value)
print(row1)

Sheet1.append(row1)
workbook1.save("01.xlsx")




workbook.save("英才学校小学部.xlsx")
